package smartcommunityserver.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import smartcommunityserver.bean.BaseCount_1_Bean;

import java.util.List;
@Mapper
public interface BaseCount_1_Mapper {
    @Select("SELECT\n" +
            "    '发货风险订单' as name ,\n" +
            "    shipping_risk_count as num\n" +
            "    FROM refund_insights.refund_one\n" +
            "WHERE window_start = '2025-09-07 00:00:00'\n" +
            "GROUP BY name ,num\n" +
            "    UNION ALL\n" +
            "    SELECT\n" +
            "        '物流风险订单' as name ,\n" +
            "        logistics_risk_count as num\n" +
            "    FROM refund_insights.refund_one\n" +
            "WHERE window_start = '2025-09-07 00:00:00'\n" +
            "GROUP BY name ,num")
    List<BaseCount_1_Bean> baseCountMapper();
}
